Add Date Column

The add date column (-adddc) function allows you to create a new date column in file-based datasets, providing date column when existing date information is missing or corrupted.

Note You can use -adddc for file-based datasets. This function does not apply to datasets based on database tables.

When you use this function, it adds a column named OWL_RUN_ID, which contains the specific run date you enter during execution.

You can use the -adddc function when the dataset:

  • Does not contain any date columns.
  • Contains malformed or unusable date strings.

Example

The following example shows a file-based dataset with the -adddc function and a run date (-rd) of 2025-07-01.

Copy 
./owlcheck \
-ds "datataset_date_column" \
-rd "2025-07-01" \
-f "/Users/Downloads/csv2/2025010.csv" \
-adddc